<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Reporte</title>
<style type="text/css">
<!--
.style7 {font-size: 12px}
.Estilo1 {
	font-size: 14px;
	font-weight: bold;
}
.Estilo3 {font-size: 36px}
.style8 {font-size: 24px}
-->
</style>
</head>

<body>
<p align="center">
  <?
include 'conexion.php';
extract($_POST);
extract($_GET)
	
/*$base= "ucg - copia";
	$conexion = mysql_connect("localhost","root","");
		mysql_select_db($base,$conexion);
     
	$conexion = mysql_connect("localhost","root","");
	mysql_select_db($base,$conexion);*/
	
   	$sqla="SELECT DISTINCT DATE_FORMAT(fecha,'%Y') from solicompra";
	$resultadoa = mysql_query($sqla, $conexion);
	
	
	?> 
<span class="style8">Reporte Orden de Compra</span></p>
<form id="form1" name="form1" method="post" action="consulta_solicompra_gen1.php">
  <table width="100%" border="1">
    <tr>
      <td width="19%"><strong>Seleccione el A&ntilde;o </strong></td>
      <td width="11%"><span class="style7">
        <select name="ano" id="ano">
          <option value="">SELECCIONE UN ANO</option>
          <? while ($busqueda = mysql_fetch_array($resultadoa)) { ?>
          <option value="<? echo $busqueda[0]; ?>"><? echo $busqueda[0];?> </option>
          <? }  ?>
        </select>
      </span></td>
    </tr>
    <tr>
      <td colspan="2"><input type="submit" name="Submit" value="Buscar">
      </td>
    </tr>
  </table>
</form>
<form action="reportes.php" method="post">
 <input name="menu" type="submit" value="Reportes">
</form>

</body>
</html>
